/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 80019
 Source Host           : 127.0.0.1:3306
 Source Schema         : microshop

 Target Server Type    : MySQL
 Target Server Version : 50799
 File Encoding         : 65001

 Date: 20/05/2020 22:26:23
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;


delete from sys_dictionary_value;
delete from sys_organization;
delete from sys_dictionary;
delete from sys_role;
delete from sys_route;
delete from sys_user;
delete from sys_user_role;


-- ----------------------------
-- Records of sys_dictionary
-- ----------------------------
BEGIN;
INSERT INTO `sys_dictionary` (`code`, `name`) VALUES ('sex', 'hello');
COMMIT;

-- ----------------------------
-- Records of sys_dictionary_value
-- ----------------------------
BEGIN;
INSERT INTO `sys_dictionary_value` (`name`, `dictionary_code`, `value`, `id`) VALUES 
('男', 'sex', 1, 697583132546830336), 
('女', 'sex', 0, 697584106749431808);
COMMIT;

-- ----------------------------
-- Records of sys_organization
-- ----------------------------
BEGIN;
INSERT INTO `sys_organization` (`name`, `sort`, `parent_id`, `id`) VALUES 
('无锡常昊软件技术有限公司', 1, -1, 706617787006717952), 
('开发部', 1, 706617787006717952, 706617881730879488), 
('市场部', 2, 706617787006717952, 706617915113345024), 
('开发测试', 2, 706617881730879488, 706618110836346880), 
('运维部署', 3, 706617881730879488, 706618172605861888), 
('dddd', 1, 706617881730879488, 706637510385733632), 
('AAA', 1, 706617915113345024, 707712752604549120);
COMMIT;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`name`, `id`) VALUES 
('开发人员', 708434238952837120), 
('HELLO', 708447504303263744), 
('你好', 708447536104476672), 
('Chiang Hao', 708447582136963072), 
('AAA', 709187721373028352), 
('DDD', 709187734849327104), 
('XXX', 709187753241350144);
COMMIT;

-- ----------------------------
-- Records of sys_route
-- ----------------------------
BEGIN;
INSERT INTO `sys_route` (`api_method`, `code`, `route`, `api_path`, `name`, `sort`, `type`, `authentication`, `parent_id`, `id`, `languate_key`, `icon`) VALUES 
(NULL, 'system', '/system', NULL, '系统设置', 1, 0, 1, -1, 1, 'system.name', NULL), 
(NULL, 'system.user', '/system/user', NULL, '用户管理', 1, 0, 1, 1, 11, 'system.sub.user', NULL), 
('', 'system.organization', '/system/organization', NULL, '组织结构', 1, 0, 1, 1, 12, 'system.sub.organization', NULL),
(NULL, 'system.role', '/system/role', NULL, '角色管理', 1, 0, 1, 1, 13, 'system.sub.role', NULL), 
(NULL, 'system.route', '/system/route', NULL, '路由管理', 1, 0, 1, 1, 14, 'system.sub.route', NULL);
COMMIT;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`is_supper_admin`, `organization_id`, `password`, `is_delete`, `name`, `id`, `account`, `avatar`) VALUES 
(1, NULL, '6KoAEsI0SWE=', 0, '超级管理员', 1, 'admin', ''), 
(0, 706617881730879488, 'vCQ8FnPqY8oGDZK/HeF/bQ==', 1, '蒋昊', 708807490594279424, 'chianghao', NULL), 
(0, 706618110836346880, 'pRurPve1Um8NRiCOEbxwVg==', 1, 'wewe', 708829837611110400, 'asdfasd', NULL),
(0, 706637510385733632, '727TlImuWKgNRiCOEbxwVg==', 1, 'DDD', 708984529511124992, 'asdfa', NULL), 
(0, 706617881730879488, 'PiOsJGeHfjI=', 1, 'AA', 708987925307723776, 'AA', NULL), 
(0, 706617881730879488, 'd7GE4F0Gzck=', 1, 'BB', 708988020098994176, 'BB', NULL), 
(0, 706637510385733632, 'YcjNhJhTNQI=', 1, 'sss', 708988058330075136, 'sss', NULL), 
(0, 706618110836346880, 'YW43ALZXQqg=', 1, 'dddd', 708988124021264384, 'asdfa', NULL), 
(0, 706618110836346880, 'YW43ALZXQqg=', 1, 'asdf', 708988142107103232, 'aaaaa', NULL), 
(0, 706618110836346880, '727TlImuWKhadwMq+sPw7GFuNwC2V0Ko', 1, 'asdfasdfas', 708988192942067712, 'asdfasdfasdfsadf', NULL),
(0, 706618110836346880, 'zSJTZB7iO9I=', 0, 'Chiang Hao', 708988214244937728, 'aaaa', NULL), 
(0, 706617787006717952, '0rBouK8RV98=', 1, 'sss', 708988265847459840, 'sss', NULL);
COMMIT;

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` (`role_id`, `user_id`) VALUES 
(708434238952837120, 708988214244937728), 
(708447504303263744, 708988214244937728),
(708447536104476672, 708988214244937728),
(709187734849327104, 708988214244937728), 
(709187753241350144, 708988214244937728);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
